<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1"><title id="pd140988">droplang</title><body><p id="client_util_desc">Removes a procedural language.</p><section id="section2"><title>Synopsis</title><codeblock id="client_util_synopsis"><b>droplang</b> [<varname>connection-option</varname> ...] [-e] <varname>langname</varname> [[<b>-d</b>] <varname>dbname</varname>]

<b>droplang</b> [<varname>connection-option</varname> ...] [-e] <b>-l</b> <varname>dbname</varname>

<b>droplang</b> <b>-? | --help</b>

<b>droplang</b> <b>-V | --version</b></codeblock></section><section id="section3"><title>Description</title><p><codeph>droplang</codeph> removes an existing procedural language from
a database. </p>
<p><codeph>droplang</codeph> is a wrapper for the SQL command <codeph><xref href="../../ref_guide/sql_commands/DROP_EXTENSION.xml#topic1"/></codeph>.</p>
  <note><codeph>droplang</codeph> is deprecated and may be removed in a future release. From
        Greenplum Database 6.x using <codeph>droplang</codeph> to remove a procedural language
        package generates an error. Use the <codeph>DROP EXTENSION</codeph> command instead.</note>

</section><section id="section4"><title>Options</title><parml><plentry><pt>langname</pt><pd>Specifies the name of the procedural language to be removed. (This name is lower-cased.)</pd></plentry><plentry><pt>[-d] <varname>dbname</varname> | [--dbname=]<varname>dbname</varname></pt><pd>Specifies from which database the language should be removed. The
default is to use the <codeph>PGDATABASE</codeph> environment variable
setting, or the same name as the current system user.</pd></plentry><plentry><pt>-e | --echo</pt><pd>Echo the commands that <codeph>droplang</codeph> generates and sends
to the server.</pd></plentry><plentry><pt>-l | --list</pt><pd>Show a list of already installed languages in the target database.
</pd></plentry>
        <plentry>
          <pt>-V | --version</pt>
          <pd>Print the <codeph>droplang</codeph> version and exit.</pd>
        </plentry>
        <plentry>
          <pt>-? | --help</pt>
          <pd>Show help about <codeph>droplang</codeph> command line arguments, and exit.</pd>
        </plentry></parml><sectiondiv id="section5"><b>Connection Options</b><parml><plentry><pt>-h <varname>host</varname> | --host=<varname>host</varname></pt><pd>The host name of the machine on which the Greenplum master database
server is running. If not specified, reads from the environment variable
<codeph>PGHOST</codeph> or defaults to localhost.</pd></plentry><plentry><pt>-p <varname>port</varname> | --port=<varname>port</varname></pt><pd>The TCP port on which the Greenplum master database server is listening
for connections. If not specified, reads from the environment variable
<codeph>PGPORT</codeph> or defaults to 5432.</pd></plentry><plentry><pt>-U <varname>username</varname> | --username=<varname>username</varname></pt><pd>The database role name to connect as. If not specified, reads from
the environment variable <codeph>PGUSER</codeph> or defaults to the current
system role name.</pd></plentry><plentry><pt>-w | --no-password</pt><pd>Never issue a password prompt. If the server requires password authentication
and a password is not available by other means such as a <codeph>.pgpass</codeph>
file, the connection attempt will fail. This option can be useful in
batch jobs and scripts where no user is present to enter a password.</pd></plentry><plentry><pt>-W | --password</pt><pd>Force a password prompt.</pd></plentry></parml></sectiondiv></section><section id="section6"><title>Examples</title><p>To remove the language <codeph>pltcl</codeph> from the <codeph>mydatabase</codeph> database:</p><codeblock>droplang pltcl mydatabase</codeblock></section><section id="section7"><title>See Also</title><p>
            <ph otherprops="op-help"><codeph><xref href="createlang.xml#topic1"/></codeph>, <codeph><xref href="../../ref_guide/sql_commands/DROP_EXTENSION.xml#topic1"/></codeph>, <codeph><xref href="../../ref_guide/sql_commands/DROP_LANGUAGE.xml#topic1"/></codeph></ph></p></section></body></topic>
